Although not considered key accounting tables, the following tables are updated by the procedures/modules that generate the main accounting data.
Subscription Module
The Subscription Module contains primary summary information on the status of each dues/subscription line item billed and/or paid for each customer. For cash-basis dues billing operations, this table also serves as a memo AR type of file with no accounting impact. The Subscription Module is used in these input/output operations to perform the following tasks:
■ Generate initial and reminder dues notices
■ Record billing payment receipts
■ Display in the Billing tab of the Manage customers window
Orders and Order_Lines
The Orders and Order_Lines table serves as the master table for both the event registration function and the simple order entry subsystem function. Orders and Order_Lines are also the main tables for Order Processing. This table is used in the following output operations:
■ Events Reports - badges, confirmation letters, labels, tickets, invoices, and rosters
■ Simple Order Entry System - Order status report (used for validation purposes) and Invoices
Activity tables
The modules that generate accounting transactions also post monetary long-term history details into the general purpose Activity table. The long-term history details can be used later for inquiry and analysis. The activity updates are the by-product of the following operations:
■ Billing Payments - Generates activity records for each line item paid
■ Event Close - Generates a single activity record for each (uncanceled) registrant, reflecting the total amount of the registration
■ Simple Order Entry & Advanced Order Entry - One product history record is generated for each line item in an invoice order
■ AR Transactions - Includes sales transactions, credit memos, and debit adjustments, and generates one product history record for each line item